Model Table WORK LOCATION

This cube dimension represents work location information in HR based on the IFS Applications dimension DIM_WORK_LOCATION. All cubes that refers to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute	Description (where applicable)
ID	Work Location Unique Identity
Work Location	Key. Displayed as CODE + ' - ' + WORK_LOCATION_DESCRIPTION
Work Location Code	Work location code e.g. company office
Work Location Description:

Hierarchies

Hierarchy

Level

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
WORK LOCATION	DIM_WORK_LOCATION_TM	DIM_WORK_LOCATION_TM	DIM_WORK_LOCATION	On Line